package com.fsy.mapper;
import com.fsy.entities.Report;
import com.fsy.entities.Roles;
import com.fsy.entities.Students_exportExcel;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;

import com.fsy.entities.Students;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author 凡凡
* @description 针对表【students】的数据库操作Mapper
* @createDate 2022-04-29 11:18:39
* @Entity com.fsy.entities.Students
*/
@Mapper
public interface StudentsMapper extends BaseMapper<Students> {
    //根据条件查询网络学生
    List<Students> selectAllByNetpusherIdAndIsValid(Students students);


    //查询条数
    int selectCounts(Students students);

    //导出excel表
    List<Students_exportExcel> exportMember(Students students);

    //导出我的学生excle表
    List<Students_exportExcel> exportMyStudents(Students students);

    /**
     * 查询全部     我的学生
     * @param students
     * @return
     */
    List<Students> selectAllByIsValidAndAskerId(Students students);

    /**
     * 查询我的学生条数
     * @param students
     * @return
     */
    int selectStudentCount(Students students);

    List<Roles> getRolesByUserId( @Param("userId") Integer userId);

    //统计各个咨询师负责的学生人数
    List<Report> askerStudentCountReport();

    // 统计各个网络咨询员录入的学生人数
    List<Report> wlzxyStudentCountReport();
}




